set hive.exec.dynamic.partition=true;            --  动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=90;         --  每天生成 60 个分区
set hive.exec.max.dynamic.partitions.pernode=90; --  每天生成 60 个分区
insert overwrite table jms_dwd.dwd_tab_day_intercept_turnback_d_dt partition(dt)
select
billcode
,type
,register_time
,register_site_code
,register_site_name
,register_proxy_area_code
,register_franchisees_code
,origin_site_code
,origin_site_name
,should_site_code
,should_site_name
,proxy_area_code
,proxy_area_name
,franchisees_code
,franchisees_name
,real_site_code
,real_site_name
,apply_type
,apply_type_code
,examine_time
,print_time
,send_time
,confirm_duration
,handle_duration
,is_handle_overtime
,is_handle_overtime_24
,send_duration
,is_send_overtime
,is_send_overtime_24
,need_sign_time
,sign_time
,is_sign_intime
,realsign_time
,is_realsign_intime
,print_network_code
,create_time
,intercept_time
,earliest_time
,sign_network_code
,sign_network_name
,deliver_network_code
,intercept_network_code
,order_source_code
,order_source_name
,deliver_network_name
,intercept_network_name
,dt
from jms_ods.tab_day_intercept_turnback_d
where dt = '{{ execution_date | cst_ds }}';
